Hello @Richards, Sam (DG-STL-HQ),

Welcome to the MS Q&A platform.

To convert Delta Parquet files to a single Parquet file with the latest version of Delta, you can use Apache Spark and Delta Lake.

df = spark.read.format("delta").load(delta_table_path)

df.show()

delta_table = DeltaTable.forPath(spark, delta_table_path)

df = delta_table.toDF()

df.show()

df = df.filter("version = (SELECT max(version) from delta_table_path)")

df.show()

df.write.parquet("parquet.delta_table_path", mode="overwrite")

If you have the plain parquet files(not using delta lake format), then you can use the below Apache spark python script to convert the plain parquet files in the folder to a single delta lake format.

Reference documents:

https://github.com/MicrosoftDocs/azure-docs/blob/main/articles/synapse-analytics/spark/apache-spark-delta-lake-overview.md

https://github.com/MicrosoftDocs/azure-docs/blob/main/articles/synapse-analytics/sql/query-delta-lake-format.md

I hope this helps. Please let us know if you have any further questions.